from exts import db

class UserModel(db.Model):
    __tablename__ = "user"
    email = db.Column(db.String(100), primary_key=True)
    password = db.Column(db.String(100), nullable=False)

class hotelinfo(db.Model):
    __tablename__ = "hotelinfo"
    hid = db.Column(db.Integer,primary_key=True)
    web = db.Column(db.String(500), nullable=True)
    hname = db.Column(db.String(500), nullable=True)
    htype = db.Column(db.String(500), nullable=True)
    city=db.Column(db.String(500), nullable=True)
    location=db.Column(db.String(500), nullable=True)
    address=db.Column(db.String(500), nullable=True)
    point=db.Column(db.String(500), nullable=True)
    photonum=db.Column(db.Integer, nullable=True)
    star=db.Column(db.Integer, nullable=True)
    suslevel=db.Column(db.String(500), nullable=True)
    susdesc=db.Column(db.String(500), nullable=True)
    creditcard=db.Column(db.String(500), nullable=True)
    features=db.Column(db.String(500), nullable=True)

class hotelroom(db.Model):
    __tablename__="rooms"
    hotel_num = db.Column(db.Integer, primary_key=True)
    hotel_im_url = db.Column(db.String(1000), nullable=True)
    hotel_name = db.Column(db.String(500), nullable=True)
    room_name = db.Column(db.String(500), nullable=True)
    choice_num =db.Column(db.Integer, primary_key=True)
    bed_type = db.Column(db.String(500), nullable=True)

    room_feature = db.Column(db.String(500), nullable=True)
    room_facility = db.Column(db.String(500), nullable=True)
    room_facilities = db.Column(db.String(500), nullable=True)
    rooms_max_people = db.Column(db.Integer, nullable=True)

    rooms_price = db.Column(db.String(500), nullable=True)
    rooms_advance_pay = db.Column(db.String(500), nullable=True)
    rooms_price_other = db.Column(db.String(500), nullable=True)
    rooms_breakfirst = db.Column(db.String(500), nullable=True)
    rooms_cancel = db.Column(db.String(500), nullable=True)
    rooms_details = db.Column(db.String(500), nullable=True)








    
